<?php 
    
function list_cetak($start , $limit,$periode){

	$header = array(
		'Tanggal'=>array('style'=>'border-bottom:2px solid;width:10%'),  
		'NIK'=>array('style'=>'border-bottom:2px solid;width:10%'),  
		'Nama Karyawan'=>array('style'=>'border-bottom:2px solid;width:20%'),  
		'Pelanggaran'=>array('style'=>'border-bottom:2px solid;width:15%'),  
		'Jenis Peringatan'=>array('style'=>'border-bottom:2px solid;width:20%'),  
		'Tindakan yang Diberikan'=>array('style'=>'border-bottom:2px solid;width:25%'),  
	);
	$query =  "SELECT * FROM tatib_detail a 
			INNER JOIN tatib b ON a.tatib_id = b.tatib_id 
			INNER JOIN jenis_peringatan c ON c.jenis_peringatan_id=a.jenis_peringatan_id";
	if( $periode<>'Semua'){		
		$query .=  " WHERE LEFT(b.tanggal,7)='{$periode}'";  	
	}		
	$query .=  " ORDER BY b.tanggal DESC";
	
	$result = my_query($query);
	$row=array();
	while($ey = my_fetch_array($result) ){
		$karyawan = loaddata_karyawan($ey['karyawan_id']); 
		$row[] = array(
			'#'=>date('d-m-Y', strtotime($ey['tanggal'])), 
			'nik'=>  $karyawan['nik'] ,
			'nama'=> $karyawan['nama_gelar'] ,   
			'uraian'=> $ey['uraian']  ,   
			'ke'=> $ey['nama_jenis_peringatan']  ,   
			'sangsi'=> $ey['sangsi']  ,   
		);

	}		
	
	$datas = table_cetak_rows($row);   
	return  table_cetak_builder($header , $datas ,  4, false );
} 
?>
<style type="text/css">
<!--

	table.page_header {width: 100%; border: none; background-color: #CDCDCD; border-bottom: solid 1mm #000; padding: 2mm }
	table.page_footer {width: 100%; border: none;  border-top: solid 1mm #000; padding: 2mm}
div.zone
{
	border: solid 2mm #66AACC;
	border-radius: 3mm;
	padding: 1mm;
	background-color: #FFEEEE;
	color: #440000;
}
div.zone_over
{
	width: 30mm;
	height: 35mm;
	overflow: hidden;
}

-->
</style>
<?php 
	if( $periode_id==0 ){
		$periode_id=get_periode_absen();
	}	
	$periodes = my_get_data_by_id('pr_periode','periode_id',$periode_id);
	$periode=substr($periodes['tanggal'],0,7) ;
	$query =  "SELECT * FROM tatib_detail a 
			INNER JOIN tatib b ON a.tatib_id = b.tatib_id 
			INNER JOIN jenis_peringatan c ON c.jenis_peringatan_id=a.jenis_peringatan_id";
	if( $periode<>'Semua'){		
		$query .=  " WHERE LEFT(b.tanggal,7)='{$periode}'";  	
	}		
	$query .=  " ORDER BY b.tanggal DESC";
		
	$result = my_query($query);
	$total = my_num_rows($result);
	$limit = 20;
	$total_page = ceil($total/$limit) -1; 
	for($i = 0; $i<=  $total_page  ;$i++):
	$start =  ( $i * $limit );
	
?>	 
<page style="font-size: 10pt">
	<page_footer>
		<table class="page_footer">
			<tr>
				<td style="width: 33%; text-align: left;">
					 HRIS RSKM 
				</td>
				<td style="width: 34%; text-align: center">
					page [[page_cu]]/[[page_nb]]
				</td>
				<td style="width: 33%; text-align: right">
					M A P &copy; 2010 - <?php echo date('Y'); ?>
				</td>
			</tr>
		</table>
	</page_footer>

	<div style="width: 100%; text-align:center; padding:2px; font-size: 13pt ;">Diciplinary Report</div>
	<?php echo list_cetak($start , $limit, $periode); ?> 
</page>
<?php endfor; ?>